import numpy as np
import pandas as pd
import matplotlib.pyplot as plt

# json_data = pd.read_json("E:\\PycharmProjects\\scientific-research\\python\\pandas\\practice\\files\\datas.json")
# print(json_data)
# json_data_arr = np.array(json_data)
# print(json_data_arr[1])
# print(json_data_arr[1].mean())

excel_data = pd.read_excel("E:\\PycharmProjects\\scientific-research\\python\\pandas\\practice\\files\\疫情数据.xlsx")
# print(excel_data.head(5))

# print(excel_data[0])
excel_data_arr = np.array(excel_data)
size = excel_data_arr.shape
# print(size,size[0])
# print(excel_data_arr[1:])
x_date = [i[0] for i in excel_data_arr]
y_data = [i[1] for i in excel_data_arr]
print(x_date)
print(y_data)
plt.plot(x_date,y_data)
plt.show()


